package com.dfbz.netctoss.mapper;


import com.dfbz.netctoss.entity.Bill;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

@org.apache.ibatis.annotations.Mapper
public interface BillMapper extends Mapper<Bill> {


    @Select("select bill.*,ac.account_real_name accountName,ac.account_idcard_no idcardNo " +
            "from bill, account ac " +
            "where bill.account_id = ac.account_id")
    List<Bill> selectAllBills();
}